Starting, stopping, and restarting MySQL services are essential database administration tasks. These operations help database administrators manage the MySQL Server, troubleshoot connection problems, apply configuration changes, and maintain database availability. MySQL services can be controlled through Windows Services, Command Prompt, Linux terminal commands, and other operating-system-specific tools.
Learn more through JustAcademy MySQL Training Course and register for a MySQL Course Demo.
After completing this topic, learners will be able to:
A MySQL service is a background operating-system process that runs the MySQL Server. It accepts client connections, executes SQL statements, manages database storage, and returns query results.
The MySQL Server process is commonly called mysqld. Depending on the operating system and installation method, its service name may be MySQL80, MySQL, mysql, or mysqld.
When you open MySQL Workbench and connect to a local database, Workbench communicates with the MySQL Server. If the server service is stopped, the connection may fail even though Workbench itself opens successfully.
| Component | Description |
|---|---|
| MySQL Server | Stores, processes, and manages database operations. |
mysqld |
The main MySQL Server executable. |
| MySQL Workbench | A graphical interface for database administration and SQL development. |
| MySQL Client | A command-line tool for connecting to and interacting with the server. |
| Windows Services | Windows interface for controlling installed services. |
systemd |
A Linux service manager used on many modern Linux distributions. |
Starting MySQL means launching the MySQL Server service so it can accept client connections and process database requests.
If MySQL Server is installed on Windows as MySQL80, you can start it using the Windows Services application or an elevated Command Prompt.
net start MySQL80Note: The service name may be different on your computer. Use the actual installed service name.
Stopping MySQL means requesting the MySQL Server to shut down. After it stops, new client connections cannot be established until the server starts again.
Important: Use a normal service stop or a supported MySQL shutdown method instead of forcibly terminating the server process. Applications that depend on the database may experience errors or downtime while the server is stopped.
Restarting MySQL means stopping the running server service and starting it again. A restart is often used after changing certain server settings or when a service needs to be reinitialized.
Some configuration changes can be applied dynamically, while others require a restart. Restarting the server is not necessary for every configuration change. Always check the documentation for the particular setting you have modified.
A restart briefly interrupts database connections. Applications may need to reconnect after the service becomes available again.
Windows provides a graphical Services application for controlling background services, including MySQL Server.
Windows + R to open the Run dialog box.services.msc.MySQL80.services.msc.Note: You may need administrator permissions to control the service. The service name depends on your MySQL installation and version.
You can control MySQL from Command Prompt using the Windows net commands. Open Command Prompt as an administrator when required.
net start MySQL80This command requests Windows to start the service named MySQL80.
net stop MySQL80This command requests Windows to stop the specified service.
sc query MySQL80Review the output to determine whether the service is running or stopped.
If the service name is unknown, use this command:
sc query state= all | findstr /I "MySQL"You can also search for MySQL services in the Services application. Replace MySQL80 in the examples with the service name installed on your computer.
Windows does not provide a universal net restart command for services. A simple method is to stop the service and then start it again.
net stop MySQL80
net start MySQL80Run these commands only when a brief database outage is acceptable. If the stop command fails, investigate the error instead of repeatedly issuing commands.
Many modern Linux installations use systemd to manage MySQL services. The service name varies by distribution and installation package. Common names include mysql and mysqld.
sudo systemctl start mysqlOn systems where the service is named mysqld, use:
sudo systemctl start mysqldsudo systemctl stop mysqlOr, where appropriate:
sudo systemctl stop mysqldsudo systemctl restart mysqlFor installations using the mysqld service name:
sudo systemctl restart mysqldsudo systemctl status mysqlIf your system uses the other service name, run:
sudo systemctl status mysqldTo configure the service to start automatically when Linux boots, use the correct service name:
sudo systemctl enable mysqlTo enable the mysqld service instead:
sudo systemctl enable mysqldsudo systemctl disable mysqlDisabling automatic startup does not necessarily stop a currently running service. Use systemctl stop separately if you intend to stop it.
Important: The commands above are alternatives, not commands that must all be run. Use the service name that exists on your Linux distribution. On systems that do not use systemd, service-management commands may differ.
mysqladmin is a MySQL administration command-line utility. It can report server status and request a graceful shutdown when the account has the required privileges.
mysqladmin -u root -p pingEnter the password when prompted. A response such as mysqld is alive indicates that the server responded to the ping request.
mysqladmin -u root -p statusThis displays a brief summary of server status information.
mysqladmin -u root -p shutdownThis requests the server to shut down. The account must have the required privileges, and you must connect to the intended server instance.
Warning: A shutdown command makes the database unavailable to applications until it is started again. For service-managed installations, prefer the operating system's service manager for routine service control.
After starting or restarting MySQL, verify that the service is running and that clients can connect.
SELECT VERSION();
SELECT NOW();The first query returns the MySQL Server version. The second returns the server's current date and time.
mysql -u root -pAfter connecting successfully, run:
SELECT VERSION();
SHOW DATABASES;If the connection fails, check the service status, host, port, username, password, and server error logs.
On Windows, use:
sc query MySQL80On Linux with systemd, use:
sudo systemctl status mysqlUse the actual service name for your installation. A service reported as running does not always guarantee that every client can connect; network settings, credentials, and permissions can still cause connection failures.
Operating systems can be configured to start a MySQL service automatically or require a manual start. The available options depend on the operating system and installation method.
| Startup Type | Meaning |
|---|---|
| Automatic | Windows attempts to start the service during system startup. |
| Automatic (Delayed Start) | Windows starts the service after other automatic services have begun, subject to its startup process. |
| Manual | The service can be started when required or by another component. |
| Disabled | The service cannot normally be started until its startup configuration is changed. |
services.msc.Choose the startup type according to the server's purpose. A development database may be started only when needed, while a production database generally requires a planned availability and recovery strategy.
| Operation | Purpose | Effect |
|---|---|---|
| Start | Launch a stopped MySQL service. | The server becomes available when startup succeeds. |
| Stop | Shut down a running MySQL service. | Existing connections are interrupted and new connections are unavailable. |
| Restart | Stop and start the service again. | Causes a temporary service interruption. |
| Enable | Configure a service to start automatically during system startup on supported systems. | Changes future startup behavior; it does not necessarily start the service immediately. |
| Disable | Prevent automatic startup on supported systems. | Changes future startup behavior; it does not necessarily stop the current service. |
| Status | Inspect the service state. | Reports service information without intentionally starting or stopping it. |
Possible causes:
Solutions:
Possible causes: The server is stopped, the host or port is incorrect, the username or password is wrong, or a firewall or network rule blocks the connection.
Solutions:
localhost for a local server.3306 unless changed.Cause: The service name in the command does not match the installed service name.
Solution: Open Windows Services or inspect the available Linux services and replace the example name with the correct one.
Cause: The current account does not have the permissions required to control the service or access the database.
Solution: Use an authorized operating-system account to manage the service and valid MySQL credentials to connect to the database. Do not bypass access controls.
Cause: Another MySQL instance or application may already be using the configured port.
Solution: Identify the process using the port and determine whether it is the intended database server. If multiple MySQL instances are required, configure distinct ports and connection settings carefully.
Possible causes: Configuration errors, data-directory access problems, incompatible settings, or resource constraints.
Solution: Review the MySQL error log and operating-system service logs. Fix the specific cause rather than repeatedly restarting the service.
Scenario: A database administrator changes a MySQL Server configuration setting that requires a restart. The administrator must restart the service and confirm that the server is accessible afterward.
On Windows, run the following in an elevated Command Prompt:
sc query MySQL80On Linux with systemd, run:
sudo systemctl status mysqlConfirm that the option is valid for the installed MySQL version and that the configuration file syntax is correct. Back up the configuration file before making significant changes.
On Windows:
net stop MySQL80
net start MySQL80On Linux, when the service is named mysql:
sudo systemctl restart mysqlOn Windows:
sc query MySQL80On Linux:
sudo systemctl status mysqlmysql -u root -pAfter connecting, execute:
SELECT VERSION();
SHOW DATABASES;| Task | Windows Command Prompt | Linux with systemd |
|---|---|---|
| Start | net start MySQL80 |
sudo systemctl start mysql |
| Stop | net stop MySQL80 |
sudo systemctl stop mysql |
| Restart | net stop MySQL80 followed by net start MySQL80 |
sudo systemctl restart mysql |
| Check status | sc query MySQL80 |
sudo systemctl status mysql |
| Enable automatic startup | Set Startup type in Services | sudo systemctl enable mysql |
| Disable automatic startup | Set Startup type in Services | sudo systemctl disable mysql |
Reminder: Windows commands use MySQL80 as an example, and Linux commands use mysql as an example. Substitute the actual service name for your system.
A MySQL service is an operating-system-managed background service that runs MySQL Server and processes database requests.
Starting launches a stopped service. Restarting stops a running service and starts it again, causing a temporary interruption.
You can use the Services application or run net start MySQL80 from an appropriately authorized Command Prompt, replacing the example name with the actual service name.
Use the Services application or run net stop MySQL80 with appropriate permissions.
On a system using systemd, run sudo systemctl restart mysql if the service is named mysql. Some installations use mysqld instead.
Check the service status through the operating system or use a client connection test such as mysqladmin -u root -p ping.
mysqladmin is a command-line administration utility that can check server status and request operations such as a graceful shutdown, subject to privileges.
A normal service restart does not intentionally delete databases. However, it temporarily interrupts connections, and unrelated configuration or storage problems may still cause issues. Always maintain backups.
Common causes include invalid configuration, insufficient permissions, data-directory problems, port conflicts, and system resource limitations.
Inspect the error logs, validate the configuration, identify the exact failure, and correct the underlying problem before retrying the start operation.
On systems using systemd, enabling a service configures it to start automatically during system startup. It does not necessarily start the service immediately.
A graceful shutdown allows the server to carry out its shutdown procedure, close resources, and handle active work more safely than forcibly terminating the process.
SELECT VERSION(); after reconnecting.Starting, stopping, and restarting MySQL services are fundamental skills for database developers and administrators. You can manage MySQL through Windows Services, Command Prompt, Linux service-management commands, and MySQL administration utilities. Always verify the service name, use a graceful shutdown, review error logs when problems occur, and confirm that the server accepts connections after starting or restarting.
To learn more about databases, SQL queries, server configuration, and practical MySQL administration, explore the JustAcademy MySQL Training Course. You can also register for a MySQL Course Demo to learn more about the training.
